Show the decimal point as( :) instead of (.)

[rmtaylor]

Hi
I have been trying without success to make a sheet I have been working on show the decimal point as ( instead of (.) The best result I have managed is (.: )by entering (0. ":" 00) in the custom box in number formatting. I would be grateful if anyone can help as my efforts does not look very professional.


[ This Message was edited by: rmtaylor on 2002-04-21 01:07 ]

[Jack in the UK]

erm soory to hear that, i fancy not allowuing Excel to solve this hy not windows...

Ok riginal setting in the control pannel ahs wonderful goodies to ply with.

try under number tab these is a decimal setting to amend to :

then click ok.

caution stays until re set.....

*MARKER DECIMAL POINT*

[smozgur]

Say your source value in A1 includes (.):

=SUBSTITUTE(A1,".",":")

What do you think?

[ This Message was edited by: smozgur on 2002-04-21 05:06 ]

[ This Message was edited by: smozgur on 2002-04-21 05:06 ]

[Chris Davison]

Smoz,

I was going to suggest that but try multiplying the result by 5 or something, it brings back a weird result

[smozgur]

Chris,

sure, this solution is just for viewing cell data required format, not for using the result in calculation.

[Chris Davison]

true !

nice solution Smozgur

[smozgur]

Just like you thought Chris..

[smozgur]

Chris,

If it is necessary to use that cell's original value reverse is possible:

A1 => =25.14

A2 => =SUBSTITUTE(A1,".",":")

A3 => =SUBSTITUTE(A2,":",".")*5

Yes?

[smozgur]

or to show A3 with ( again;

A3 => =SUBSTITUTE(SUBSTITUTE(A2,":",".")*5,".",":")

[Chris Davison]

Yes,

the *5 co-erces the text back into a number

Chris