ExcelBanter - Custom Number formats adding months after numerals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom Number formats adding months after numerals (https://www.excelbanter.com/excel-discussion-misc-queries/156900-custom-number-formats-adding-months-after-numerals.html)

Smudge

Custom Number formats adding months after numerals

Hi,

Hoping some one can help me please.

I'm trying to add the word months after a number so that the cell has a
number format and can be used in calculations afterwards.

I've tried 0_"months";-0_"months"

but it doesn't like it. If anyone can help that would be brilliant.

TIA
--
Smudge

Peo Sjoblom

Custom Number formats adding months after numerals

Try

0" Months"

--
Regards,

Peo Sjoblom

"Smudge" wrote in message
...
Hi,

Hoping some one can help me please.

I'm trying to add the word months after a number so that the cell has a
number format and can be used in calculations afterwards.

I've tried 0_"months";-0_"months"

but it doesn't like it. If anyone can help that would be brilliant.

TIA
--
Smudge

Smudge

Custom Number formats adding months after numerals

It liked that!

Thank you so much
--
Smudge

"Peo Sjoblom" wrote:

Try

0" Months"

--
Regards,

Peo Sjoblom

"Smudge" wrote in message
...
Hi,

Hoping some one can help me please.

I'm trying to add the word months after a number so that the cell has a
number format and can be used in calculations afterwards.

I've tried 0_"months";-0_"months"

but it doesn't like it. If anyone can help that would be brilliant.

TIA
--
Smudge

All times are GMT +1. The time now is 02:18 PM.