ExcelBanter - Convert number

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

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

- - Convert number (https://www.excelbanter.com/excel-discussion-misc-queries/167316-convert-number.html)

Spiros

Convert number

I want to convert a number into a different format. For example the number
1205050000 (without fullstops) will be converted to 12.05.05.0000 (with 3
fullstops).

MartinW

Convert number

Hi Spiros,

Maybe FormatCellsNumber and apply a
custom format of 00"."00"."00"."0000

HTH
Martin

"Spiros" wrote in message
...
I want to convert a number into a different format. For example the number
1205050000 (without fullstops) will be converted to 12.05.05.0000 (with 3
fullstops).

Spiros

Convert number

MartinW, Thank you a lot
Spirow

ÎŸ Ï‡ÏÎ®ÏƒÏ„Î·Ï‚ "MartinW" Î*Î³Î³ÏÎ±ÏˆÎµ:

Hi Spiros,

Maybe FormatCellsNumber and apply a
custom format of 00"."00"."00"."0000

HTH
Martin

"Spiros" wrote in message
...
I want to convert a number into a different format. For example the number
1205050000 (without fullstops) will be converted to 12.05.05.0000 (with 3
fullstops).

All times are GMT +1. The time now is 03:35 PM.