ExcelBanter - Change the format of the cell

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

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

- - Change the format of the cell (https://www.excelbanter.com/excel-discussion-misc-queries/75467-change-format-cell.html)

nick

Change the format of the cell

Hi,

I have a cell with 8 characters "12345678" and i need to format it as
12-345678. How do i do this? Someone plz help

CLR

Change the format of the cell

Right-click FormatCells NumberTab Custom put ##-###### in the Type:
window ok

Vaya con Dios,
Chuck, CABGx3

"nick" wrote:

Hi,

I have a cell with 8 characters "12345678" and i need to format it as
12-345678. How do i do this? Someone plz help

nick

Change the format of the cell

Thank You

"CLR" wrote:

Right-click FormatCells NumberTab Custom put ##-###### in the Type:
window ok

Vaya con Dios,
Chuck, CABGx3

"nick" wrote:

Hi,

I have a cell with 8 characters "12345678" and i need to format it as
12-345678. How do i do this? Someone plz help

All times are GMT +1. The time now is 10:14 AM.