| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell formatting
If you have a cell in a worksheet displayed in the format 2.190,27 is there anyway in which this number can be displyed automatically in another worksheet as 2190.27? i.e without having to manually intervene and replace . with , etc? -- jamesmchardy ------------------------------------------------------------------------ jamesmchardy's Profile: http://www.excelforum.com/member.php...o&userid=34295 View this thread: http://www.excelforum.com/showthread...hreadid=540602 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell formatting
Hi James,
Are you 100% sure that the first cell is indeed a number: 2.190,27 ... Carim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell formatting
=REPLACE(A1,6,1,"")*1000
Vaya con Dios, Chuck, CABGx3 "jamesmchardy" wrote: If you have a cell in a worksheet displayed in the format 2.190,27 is there anyway in which this number can be displyed automatically in another worksheet as 2190.27? i.e without having to manually intervene and replace . with , etc? -- jamesmchardy ------------------------------------------------------------------------ jamesmchardy's Profile: http://www.excelforum.com/member.php...o&userid=34295 View this thread: http://www.excelforum.com/showthread...hreadid=540602 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Linear Mode
